SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Own a piece of early New England history with waterfront — a rare combination that almost never comes available. This iconic 1812 stone home sits on a level 0.98-acre lot and includes 130 feet of owned Connecticut River frontage just across the quiet country road, offering easy access for kayaking, fishing, paddle boarding, or simply enjoying the ever-changing water views. Inside, the home blends historic character with comfortable living. The first floor offers a warm and inviting living room with wood stove, country kitchen with dining nook, formal dining room, first-floor bedroom, half bath, sun porch, workshop space, and generous storage. Upstairs you'll find a large primary bedroom, office, and full bath, while the third level provides an additional bedroom and flexible bonus space perfect for guests, studio, or work-from-home use. Original details remain throughout — maple floors on the main level, wide pine floors above, and deep farmhouse window trim — creating the charm only a true period home can offer. Outside, the property is equally special, with mature landscaping, established garden areas, patio space, and a workshop/shed. The river frontage across the road expands the lifestyle, giving you your own personal access to the Connecticut River without sacrificing privacy at the house site. Conveniently located just minutes to I-91 and an easy bike ride to Post Pond and Cedar Circle Farm, this property offers a unique blend of history, recreation, and rural tranquility — a setting increasingly difficult to find in the Upper Valley. Just a 20 minute drive to downtown Hanover & Dartmouth College. High School Choice.
Description:Surrounded by the landscapes that inspired generations of artists in the former Cornish Art Colony, where grand old homes from another era keep watch, sits a homestead that has been lovingly and extensively restored by the current owners. The interior is a complete, custom renovation, with all the charm. It feels like the farmhouse you've been picturing for years: wide pine floors underfoot, post-and-beam bones overhead, and vertical nickel-gap shiplap that adds warmth and dimension. At the center of it all is a custom kitchen built around the idea that the best nights happen when everyone crowds in. Source a big farmhouse table for friends and family to gather around and let dinner take its time. One-level living comes easy with a main-floor bedroom and full bath, while upstairs two more bedrooms share a renovated bath with walk-in shower and claw-foot tub for long soaks. When the weather turns, the Jotul woodstove does what a woodstove should - pulls the whole house in close, while you watch the snow fall outside. The storied barn anchors the home's ell and welcomes you to the mudroom. Tucked away at the end of the ell is a simple studio space - a place that invites imagination, whether envisioned as a workshop, a creative haven, or private guest quarters apart from the main home. Outside, the landscape unfolds with a sense of abundance. Mornings begin on the covered deck with coffee in hand and the sound of the Blow-Me-Down Brook winding its way along the property's edge. On warm summer days, a beloved swimming hole offers a refreshing escape, while the historic Blow-Me-Down Covered Bridge stands as a timeless backdrop to daily life. For those drawn to hiking, the Top-of-the-World trails just up the road offer scenic views of Ascutney. A chicken coop, garden space, fruit trees, and acres of tillable field offer the opportunity to cultivate a more connected way of living.
Description:Finally, a lake property that lets you relax. Enjoy the Mascoma Lake lifestyle without many of the maintenance demands and costs often associated with traditional waterfront ownership. This beautifully maintained 3-bedroom, 3-bath home includes access to two shared sandy beaches and conveys with an optional boat slip—allowing owners to keep a boat in the water all season without the hassle of trailering, installing, or removing docks. From peaceful mornings on the lake to evenings on the screened porch listening to loons across the water, this property was designed for enjoying the Upper Valley lifestyle rather than maintaining it. The communities private sandy beach offers a quieter alternative to crowded public areas and creates an ideal setting for swimming, paddleboarding, kayaking, and summer gatherings. Thoughtfully designed for both everyday living and entertaining, the home features a warm and inviting living room with wood-burning fireplace, granite kitchen, flexible first-floor bedroom or office, and seamless access to the screened porch with lake views. Upstairs, the primary suite offers vaulted ceilings, walk-in closet, and private bath, while the walkout lower level provides additional space for recreation, fitness, media, or hobbies. Located just minutes from downtown Lebanon, I-89, Dartmouth Hitchcock Medical Center, Dartmouth College, dining, shopping, and Upper Valley amenities, this property offers a rare combination of lake access, convenience, and low-maintenance enjoyment.
Description:A sportsman's Paradise! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Mascoma Lake, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.
Description:Beach Access! Step into timeless elegance with this extraordinary 1929 Classical Revival home, where historic craftsmanship and gracious living come together beautifully. Period details include ornate plaster moldings, stained and beveled glass windows, quarter-sawn oak floors, rich mahogany doors, extra-high ceilings, a sweeping front staircase, and a classic fireplace that creates a warm, dramatic sense of arrival. Offering nearly 5,000 square feet, the home features five bedrooms and six baths, including four ensuite bedrooms for comfort and privacy. Two expansive porches, including a screened porch, overlook spectacular perennial gardens filled with layered plantings, seasonal blooms, and mature landscaping that provide color and fragrance from spring through fall. Pollinator-friendly varieties attract birds and butterflies, while established borders and intimate garden spaces create a serene, park-like setting ideal for morning coffee, sunset gatherings, and evening stargazing. A charming portico and garage add convenience while preserving architectural character. Ideally located in Historic Shaker Village minutes from Dartmouth College and Dartmouth Health, the property offers rare flexibility. Formerly a successful bed and breakfast and now a single-family residence, it is well suited for elegant private living or renewed hospitality use. Enjoy year-round recreation with nearby lake activities, rail trails, and mountain biking, plus easy access to multiple ski areas including Whaleback, Sunapee, Dartmouth Skiway, and Ragged Mountain, with Killington, Stowe, and Loon about an hour away. Completing this remarkable offering is a peaceful, private meditation chapel — a truly unique retreat space that sets this home apart.
Description:Set on 11.5 private acres in scenic Plainfield, New Hampshire, this beautifully designed 2021 home offers the perfect balance of comfort, privacy, and modern living. The main living area is warm and welcoming, centered around a striking stone hearth with a propane fireplace. The bright kitchen opens seamlessly to the living and dining areas, creating an easy flow for everyday living and entertaining. An oversized 2-car garage offers direct entry into the home, while a dedicated laundry room and half bath are conveniently tucked just off the kitchen. A spacious wraparound deck expands the living space outdoors, providing a peaceful setting for summer dining, relaxing, and enjoying the surrounding landscape and water views. The primary suite features a beautifully appointed en suite bath and walk-in closet. The finished lower level offers a large sauna, flexible space for a gym, office, media room, or additional living area. A whole-house generator adds year-round peace of mind. Surrounded by nature yet conveniently located with easy access to Hanover, Lebanon, Shopping, Dartmouth College, and Dartmouth Hitchcock Medical Center, this property offers a wonderful blend of privacy, convenience, and Upper Valley living.